Columns

Grants

Dependencies

Details

Triggers

Errors


COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID COMMENTS INSERTABLE UPDATABLE DELETABLE
THECOUNT NUMBER Yes null 1 null NO NO NO
USERNAME VARCHAR2(256 CHAR) Yes null 2 null NO NO NO
THEDATE VARCHAR2(10 CHAR) Yes null 3 null NO NO NO
PRIVILEGE GRANTEE GRANTABLE GRANTOR OBJECT_NAME
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE



References


NAME VALUE
CREATED 03-APR-23
LAST_DDL_TIME 03-APR-23
OWNER QART
VIEW_NAME V_METRICS_LAUNCHES
TEXT_LENGTH 241
TEXT SELECT COUNT ('x') AS THECOUNT, USERNAME, TO_CHAR (TRUNC (LOG_DATE), 'MM/DD/YYYY') AS THEDATE        FROM METRICS$       WHERE METRIC = 'LAUNCHED' AND TRUNC (LOG_DATE) > SYSDATE - 30    GROUP BY USERNAME, TRUNC (LOG_DATE)    ORDER BY THEDATE
TEXT_VC SELECT COUNT ('x') AS THECOUNT, USERNAME, TO_CHAR (TRUNC (LOG_DATE), 'MM/DD/YYYY') AS THEDATE        FROM METRICS$       WHERE METRIC = 'LAUNCHED' AND TRUNC (LOG_DATE) > SYSDATE - 30    GROUP BY USERNAME, TRUNC (LOG_DATE)    ORDER BY THEDATE
TYPE_TEXT_LENGTH null
TYPE_TEXT null
OID_TEXT_LENGTH null
OID_TEXT null
VIEW_TYPE_OWNER null
VIEW_TYPE null
SUPERVIEW_NAME null
EDITIONING_VIEW N
READ_ONLY N
CONTAINER_DATA N
BEQUEATH DEFINER
ORIGIN_CON_ID 16
DEFAULT_COLLATION USING_NLS_COMP
CONTAINERS_DEFAULT NO
CONTAINER_MAP NO
EXTENDED_DATA_LINK NO
EXTENDED_DATA_LINK_MAP NO
HAS_SENSITIVE_COLUMN NO
ADMIT_NULL NO
PDB_LOCAL_ONLY NO
DUPLICATED N
SHARDED N
OWNER TRIGGER_NAME TRIGGER_TYPE TRIGGERING_EVENT STATUS OBJECT_ID




ATTRIBUTE Line:Position TEXT